PATOLOGIAS

"192.168.0.1:sipop"

PATOLOGIAS

Descriptions

CLASIFICACION DE
PATOLOGIAS REGISTRADAS EN EL SISTEMA

Fields

Name	Data type	Description
ID_PATOLOGIAS	CHAR (13)	ID de la patologia
ID_PADRE_PATOLOGIA	CHAR (13)	ID del tipo de patologia
NOMBRE	VARCHAR (80)	Nombre de la patologia
HIJOS	INTEGER	Patologias dependeintes en la gerarquia

Triggers

Trigger	Type	Position
PATOLOGIAS_AI	After Insert	0
PATOLOGIAS_AU	After Delete	0
PATOLOGIAS_BD	Before Delete	0
PATOLOGIAS_BI	Before Insert	0
PATOLOGIAS_BU2	Before Update	1

Indices

Index	Fields	Active	Unique	Order
PK_PATOLOGIAS	ID_PATOLOGIAS			Ascending

References

There are no references for table PATOLOGIAS

Referenced

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
PATOPOREXPE	FK_PATOPOREXPE	PATOLOGIA	ID_PATOLOGIAS	RESTRICT	RESTRICT

Definition


CREATE TABLE PATOLOGIAS (
    ID_PATOLOGIAS CHAR (13) CHARACTER SET WIN1251 NOT NULL COLLATE WIN1251,
    ID_PADRE_PATOLOGIA CHAR (13) CHARACTER SET WIN1251 COLLATE WIN1251,
    NOMBRE VARCHAR (80) CHARACTER SET WIN1251 COLLATE WIN1251,
    HIJOS INTEGER);

ALTER TABLE PATOLOGIAS ADD CONSTRAINT PK_PATOLOGIAS PRIMARY KEY (ID_PATOLOGIAS);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.